Problem Note 56760: When you use SAS/ACCESS® Interface to Hadoop to query Hadoop Hive tables, the SQL queries fail and an error occurs
When you use SAS/ACCESS Interface to Hadoop to query Hive tables, your SQL queries might fail, resulting in the following error:
ERROR: Execute error: Error while compiling statement: FAILED: SemanticException [Error 10036]:
Duplicate column name:
The problem occurs when there are duplicate column names in the table.
To resolve the problem, rename the column in the Hadoop table using Hue or a similar utility.
Note: In SAS® 9.4 TS1M2 and earlier, the job stops responding. In this situation, kill the job.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Hadoop | Windows 7 Ultimate x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Ultimate 32 bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Professional x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Professional 32 bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Home Premium x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Home Premium 32 bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Windows 7 Enterprise 32 bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 Std | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2008 R2 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows Server 2008 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8.1 Pro | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Pro x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M2 | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 9.4 TS1M2 | 9.4 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
SAS SQL queries might stop responding when using SAS/ACCESS Interface to Hadoop to query Hadoop tables. The following error occurs:
ERROR: Execute error: Error while compiling statement: FAILED: SemanticException [Error 10036]: Duplicate column name
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2015-10-20 11:22:18 |
| Date Created: | 2015-10-09 10:00:37 |
